<?php
$dsn = "sqlsrv:Server=localhost;Database=Task";
$db = new PDO($dsn, "sa", "123456");

$sql = 'select * from Task';
$result = $db->query($sql);
$taskList = $result->fetchAll(PDO::FETCH_ASSOC);
?>


<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>列表</title>
    <link rel="stylesheet" type="text/css" href="css/main.css" />

</head>
<body>
<div id="container">
    <div id="login_info">
        欢迎你：admin
        <a href="logout.html">退出登录</a>
    </div>
    <div id="choose_div">
        <input type="checkbox" id="all" onclick="swapCheck()">全选</input>
        <a id="multi_delete" href="javascript:void(0);">删除选中任务</a>

        <a id="add" href="update.php" style="float: right">增加任务</a>
    </div>
    <table class="list">
        <tbody>
        <tr>
            <th></th>
            <th>任务id</th>
            <th>任务名称</th>
            <th>任务状态</th>
            <th>创建时间</th>
            <th>修改时间</th>
            <th>操作</th>
        </tr>
        <?php foreach ($taskList as $key=>$value):?>
        <tr>
            <td><input type="checkbox" class="task-checkbox" name="TaskId[]" value=""></td>
            <td><?php
                echo $value['TaskId']
                ?>
            </td>
            <td><?php
                echo $value['TaskName']
                ?>
            </td>
            <td><?php
                if ($value['TaskStatus']==1){
                    echo "新创建";
                }else if ($value['TaskStatus']==2){
                    echo "进行中";
                }else if ($value['TaskStatus']==3){
                    echo "已完成";
                }
                ?>
            </td>
            <td>
                <?php
                echo $value['TaskCreateTime']
                ?>
            </td>
            <td><?php
                echo $value['TaskUpdateTime']
                ?></td>
            <td>
                <a class="update_ing" href="detail.php?task_id=<?php echo $value['TaskId']?>">详情</a>
                <a href="javascript:if(confirm('确认删除吗？'))window.location='delete.php?task_id=<?php echo $value['TaskId']; ?>'">删除</a>
            </td>
        </tr>
        <?php
        endforeach;
        ?>
        </tbody>
    </table>
    <script type="text/javascript"
            src="http://apps.bdimg.com/libs/jquery/2.1.1/jquery.min.js"></script>
    <script type="text/javascript">
        //checkbox 全选/取消全选
        var isCheckAll = false;
        function swapCheck() {
            if (isCheckAll) {
                $("input[type='checkbox']").each(function() {
                    this.checked = false;
                });
                isCheckAll = false;
            } else {
                $("input[type='checkbox']").each(function() {
                    this.checked = true;
                });
                isCheckAll = true;
            }
        }
    </script>

</div>
</body>
</html>
